package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * 执行UPDATE语句
 */
public class JDBCDemo3 {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/tedu?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true",
                "root",
                "root");
        System.out.println("链接数据库成功");

        Statement statement=connection.createStatement();
        /**
         * UPDATE user
         * set password='666666'
         * where name='张三'
         */
        String sql="UPDATE user " +
                //注意在set和where前面加空格
                 "SET password='666666' " +
                 "WHERE name='张三'"; // 修正了此处的列名从username到name以匹配数据库实际结构
        System.out.println( sql);
        int num= statement.executeUpdate(sql);
        System.out.println(num>0? "修改成功":"修改失败");
        connection.close();

    }
}
